﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_PRODUCT_GET_ALL')
	BEGIN
		DROP  Procedure  P_PRODUCT_GET_ALL
	END

GO

CREATE Procedure P_PRODUCT_GET_ALL

AS

SELECT [PRODUCT_ID]
      ,[PRODUCT_CATEGORY]
      ,[PRODUCT_NAME]
      ,[PRODUCT_PIC]
      ,[PRODUCT_DESC]
      ,[PRODUCT_UNIT_PRICE]
      ,[PRODUCT_INVENTORY]
      ,[VERSION_NO]
      ,[TRANSACTION_ID]
      ,[CREATED_BY]
      ,[CREATED_TIME]
      ,[LAST_UPDATED_BY]
      ,[LAST_UPDATED_TIME]
  FROM [dbo].[T_PRODUCT]
GO